MS Excel: NPV Function (WS, VBA) - TechOnTheNet.com Learn how to use the Excel NPV function with syntax and examples. The Microsoft Excel NPV function returns the net present value of an investment.